Keywords: if the host string in oracle is connected to the local database using the local SQL * Plus, ldquo; host string rdquo; can be empty. For remote connection
Keywords: if the host string in oracle is connected to the local database using the
1.oracle InstallationRefer to http://wenku.baidu.com/view/d01ffd43336c1eb91a375d68.html, no longer repeat here2. Command line sqlplus Connect Oracle(1) Check the monitoring statusc:\>lsnrctl StatusLsnrctl for 32-bit windows:version
1. Oracle Installation
Please refer to the following link for more information: http://wenku.baidu.com/view/d01ffd43336c1eb91a375d68.html.
2. Use the command line sqlplus to connect to Oracle
(1) Check the listening status
C: \> LSNRCTL
Keywords: host string in Oracle
If the local SQL * Plus is used to connect to the local database, the "host string" can be blank.
To remotely connect to the xp oracle database, use the following method:1. Start oracle-related servers in windows;2.
ora-28009:connection as SYS should be as Sysdba
Afraid to forget can:
Click "Password Management", Open Password Management dialog box, such as figure, set SYS, and system user password, can be set to the same, username and password are the same,
Today, with the isql*plus to the SYS user to connect to the database when the ora-28009:connection as SYS should be as SYSDBA or sysoper error, do not know what is going on, Remember when the connection of the time when the error did not report on
detailed installation and uninstallation of the oracle9iThis chapter describes the installation of the Oracle9i database as an example of the Windows operating systemThe main contents include:Pre-Installation Preparationinstallation of the Oracle9i
Oracle and MySql knowledge SummaryHow SQL plus connects to the database1> enter sqlplus username/password @ database instance in cmdFor example, sqlplus system/lxr316 @ oracle,Sqlplus sys/admin as sysdba2> open sqlplus and enter the user name and
The Client service name establishes a connection to a remote or local listener that the client uses to issue a connection request to the server side.When Oracle is installed, the user must specify a global database name, a SID name. Oracle
Sqlplus How to connect to a database1> cmd input: sqlplus user name/password @ DB instancesuch as: Sqlplus System/[email protected],Sqlplus Sys/admin as Sysdba2> Open Sqlplus Enter your username and password directly3> use command: Connect sys/admin
This is a creation in
Article, where the information may have evolved or changed.
NET package provides a portable interface for network I/O, including TCP/IP,UDP, domain name resolution, and UNIX sockets. Although the net package provides a lot of
The tool jar package can be in: http://download.csdn.net/detail/shenjianox/7769783
GANYMED-SSH2 Introduction:
Ganymed SSH-2 for Java is a package that implements the SSH-2 protocol in pure Java. In the process of using it, it is very easy to
(1) ORACLE Server Configuration:
NOTE: If your Oracle is used as a server, your Oracle will start the listener service, corresponding to oracleorahome92tnslistener in the Windows Service, which is configured with IP + port + database, then
1, directly with Sql*plus directly connectedDatabaseWhen using Sql*plus to connect to the database, a dialog box is required to fill in the user name, password, and host string information. The former two needless to say, I will fill in the right,
The tool jar package is available in: http://download.csdn.net/detail/shenjianox/7769783 and documentationGANYMED-SSH2 Introduction:Ganymed SSH-2 for Java is a package that implements the SSH-2 protocol with pure Java. It's very easy to use it,
Ganymed SSH-2 for Java is a package that implements the SSH-2 protocol in pure Java. In the process of using it is very easy, only to specify a legitimate username password, or authorization to authenticate files, you can create a connection to a
Oracle| Program Oracle Configuration Instructions
Lixin (University of Petroleum, East China) School of Computer and communication engineering, Dongying 257061, Shandong;
1. Objective
After the Oracle installation is successful, some basic
Reference: http://www.zhetao.com/content240In real-world development applications, about Oracle databases, it is often heard that a database is created, a instance is created, and a instance is started.Actually ask them what is the database, what is
Here are two ways to log in, with Sqlplus login need to enter the host Word:If you are using native Sql*plus to connect to the native database, the host string can be empty.If you are connecting to an Oracle database remotely from XP, you can use
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.